ApiWorksheetFunction
Represents the ApiWorksheetFunction class.
Methods
- ASC
- CHAR
- CLEAN
- CODE
- CONCATENATE
- DOLLAR
- EXACT
- FIND
- FINDB
- FIXED
- LEFT
- LEFTB
- LEN
- LENB
- LOWER
- MID
- MIDB
- NUMBERVALUE
- PROPER
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- SEARCH
- SEARCHB
- SUBSTITUTE
- T
- TEXT
- TRIM
- UNICHAR
- UNICODE
- UPPER
- VALUE
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETA_DIST
- BETA_INV
- BETAINV
- BINOMDIST
- BINOM_DIST
- BINOM_DIST_RANGE
- BINOM_INV
- CHIDIST
- CHIINV
- CHISQ_DIST
- CHISQ_DIST_RT
- CHISQ_INV
- CHISQ_INV_RT
- CHITEST
- CONFIDENCE
- CONFIDENCE_NORM
- CONFIDENCE_T
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- CRITBINOM
- DEVSQ
- EXPON_DIST
- EXPONDIST
- F_DIST
- FDIST
- F_DIST_RT
- F_INV
- FINV
- F_INV_RT
- FISHER
- FISHERINV
- FORECAST_ETS
- FORECAST_ETS_CONFINT
- FORECAST_ETS_SEASONALITY
- FORECAST_ETS_STAT
- FREQUENCY
- GAMMA
- GAMMA_DIST
- GAMMADIST
- GAMMA_INV
- GAMMAINV
- GAMMALN
- GAMMALN_PRECISE
- GAUSS
- GEOMEAN
- GROWTH
- HARMEAN
- HYPGEOMDIST
- HYPGEOM_DIST
- KURT
- LARGE
- LINEST
- LOGEST
- LOGINV
- LOGNORM_DIST
- LOGNORM_INV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- NEGBINOMDIST
- NEGBINOM_DIST
- NORMDIST
- NORM_DIST
- NORMINV
- NORM_INV
- NORMSDIST
- NORM_S_DIST
- NORMSINV
- NORM_S_INV
- PERCENTILE
- PERCENTILE_EXC
- PERCENTILE_INC
- PERCENTRANK
- PERCENTRANK_EXC
- PERCENTRANK_INC
- PERMUT
- PERMUTATIONA
- PHI
- POISSON
- POISSON_DIST
- QUARTILE
- QUARTILE_EXC
- QUARTILE_INC
- RANK
- RANK_AVG
- RANK_EQ
- SKEW
- SKEW_P
- SMALL
- STANDARDIZE
- STDEV
- STDEV_S
- STDEVA
- STDEVP
- STDEV_P
- STDEVPA
- TDIST
- T_DIST
- T_DIST_2T
- T_DIST_RT
- T_INV
- T_INV_2T
- TINV
- TREND
- TRIMMEAN
- VAR
- VARA
- VARP
- VAR_P
- VAR_S
- VARPA
- WEIBULL
- WEIBULL_DIST
- ZTEST
- Z_TEST
- DATE
- DATEVALUE
- DAY
- DAYS
- DAYS360
- EDATE
- EOMONTH
- HOUR
- ISOWEEKNUM
- MINUTE
- MONTH
- NETWORKDAYS
- NETWORKDAYS_INTL
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- WEEKNUM
- WORKDAY
- WORKDAY_INTL
- YEAR
- YEARFRAC
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
- COMPLEX
- CONVERT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- ERF
- ERF_PRECISE
- ERFC
- ERFC_PRECISE
- GESTEP
- HEX2BIN
- HEX2DEC
- HEX2OCT
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- OCT2BIN
- OCT2DEC
- OCT2HEX
- DAVERAGE
- DCOUNT
- DCOUNTA
- DGET
- DMAX
- DMIN
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DVAR
- DVARP
- ACCRINT
- ACCRINTM
- AMORDEGRC
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CUMIPMT
- CUMPRINC
- DB
- DDB
- DISC
- DOLLARDE
- DOLLARFR
- DURATION
- EFFECT
- FV
- FVSCHEDULE
- INTRATE
- IPMT
- IRR
- ISPMT
- MDURATION
- MIRR
- NOMINAL
- NPER
- NPV
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- PDURATION
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- RRI
- SLN
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
- ABS
- ACOS
- ACOSH
- ACOT
- ACOTH
- AGGREGATE
- ARABIC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- BASE
- CEILING
- CEILING_MATH
- CEILING_PRECISE
- COMBIN
- COMBINA
- COS
- COSH
- COT
- COTH
- CSC
- CSCH
- DECIMAL
- DEGREES
- ECMA_CEILING
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FLOOR
- FLOOR_PRECISE
- FLOOR_MATH
- GCD
- INT
- ISO_CEILING
- LCM
- LN
- LOG
- LOG10
- MOD
- MROUND
- MULTINOMIAL
- MUNIT
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SEC
- SECH
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMSQ
- TAN
- TANH
- TRUNC
- CHOOSE
- COLUMNS
- HLOOKUP
- HYPERLINK
- INDEX
- LOOKUP
- MATCH
- ROWS
- TRANSPOSE
- VLOOKUP
- ERROR_TYPE
- ISERR
- ISERROR
- ISEVEN
- ISFORMULA
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISREF
- ISTEXT
- N
- NA
- SHEET
- SHEETS
- TYPE
- AND
- FALSE
- IF
- IFERROR
- IFNA
- NOT
- OR
- TRUE
- XOR